GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet.Charts Namespace / ISeriesCollection Interface / Add Method / Add(WorksheetReference,Nullable<RowCol>,Nullable<Boolean>,Nullable<Boolean>,Boolean) Method
The new data as an GrapeCity.Spreadsheet.IRange object.
Specifies whether the new values are in the rows or columns of the specified range. If this argument is omitted, Spread attempts to determine where the values are by the size and orientation of the selected range or by the dimensions of the array.
true if the first row or column contains the name of the data series. false if the first row or column contains the first data point of the series. If this argument is omitted, Spread attempts to determine the location of the series name from the contents of the first row or column.
true if the first row or column contains the name of the category labels. false if the first row or column contains the first data point of the series. If this argument is omitted, Spread attempts to determine the location of the category label from the contents of the first row or column.
If categoryLabels is true and replace is false, the specified categories replace the categories that currently exist for the series. If replace is false, the existing categories will not be replaced.


In This Topic
Add(WorksheetReference,Nullable<RowCol>,Nullable<Boolean>,Nullable<Boolean>,Boolean) Method
In This Topic
Adds one or more new series to the ISeriesCollection collection.
Syntax
'Declaration
 
Overloads Function Add( _
   ByVal source As WorksheetReference, _
   Optional ByVal plotBy As Nullable(Of RowCol), _
   Optional ByVal seriesLabels As Nullable(Of Boolean), _
   Optional ByVal categoryLabels As Nullable(Of Boolean), _
   Optional ByVal replace As Boolean _
) As ISeries
 
'Usage
 
Dim instance As ISeriesCollection
Dim source As WorksheetReference
Dim plotBy As Nullable(Of RowCol)
Dim seriesLabels As Nullable(Of Boolean)
Dim categoryLabels As Nullable(Of Boolean)
Dim replace As Boolean
Dim value As ISeries
 
value = instance.Add(source, plotBy, seriesLabels, categoryLabels, replace)

Parameters

source
The new data as an GrapeCity.Spreadsheet.IRange object.
plotBy
Specifies whether the new values are in the rows or columns of the specified range. If this argument is omitted, Spread attempts to determine where the values are by the size and orientation of the selected range or by the dimensions of the array.
seriesLabels
true if the first row or column contains the name of the data series. false if the first row or column contains the first data point of the series. If this argument is omitted, Spread attempts to determine the location of the series name from the contents of the first row or column.
categoryLabels
true if the first row or column contains the name of the category labels. false if the first row or column contains the first data point of the series. If this argument is omitted, Spread attempts to determine the location of the category label from the contents of the first row or column.
replace
If categoryLabels is true and replace is false, the specified categories replace the categories that currently exist for the series. If replace is false, the existing categories will not be replaced.
See Also